Prime Minister Rishi Sunak has apologised on behalf of the Government for the “horrific” historic treatment of LGBT people serving in the military.