Prince Andrew asked Elizabeth II to restore him to the rank of colonel