Given the open rows Trump had with the FBI and the CIA, that these agencies are filled with democrats and even republican sympathisers who think Trump should be impeached, and that an abuse of power is the very raison d’etre of the impeachment procedure, I don’t see how he would get to give such an order without the whole world knowing about it. Doesn’t pass the smell test.
Foreign agency, different story. But there are enough people with a smartphone in the US that it doesn’t take a state-backed agency to obtain a compromising picture of a well known public figure.