The revelation that Elizabeth II wanted the United Kingdom to stay in the European Union – despite a particularly lurid tabloid headline during the Brexit referendum campaign to the contrary – will come as little surprise to those who knew Her Majesty, says Harry Mount