King Charles was forced to write a letter of apology to a royal protection officer who was sacked after a scandal involving the future monarch and a glass of cherry brandy