The Duke of York has said he is “grateful” for an apology from police after officers challenged him in the gardens of Buckingham Palace less than 48 hours after a break-in at the Queen’s home.