The Prime Minister was greeted with jeers and whistles as he climbed the steps of St Paul's Cathedral for a National Thanksgiving Service for the Queen.