Queen Elizabeth II has stripped Prince Andrew of all his honorary military titles and royal roles in charities and other civic groups.