"No, they didn't,"
I'm afraid they did. It was the people of England who voted to leave, and since we live in a democracy, and they have the majority, their view prevailed.
As John Major, a "Retainer", said at the time of the referendum, "The Tyranny of the Majority".
We are seeing the inevitable result of government by referendum - there is no "wriggle room", you are committed, as Cameron found out to his cost. No endless debate about what was, or was not, in the manifesto.
It doesn't matter whether there is another independence referendum in Scotland, or a third, fourth or another twenty. No-one in Scotland, in the UK, or in the whole of Europe can be in any doubt that the SNP is in favour of independence, and they will keep pushing for it, no matter what promises about "once in a generation, in twenty years, or even a hundred years" are made, and they will see the result, whichever way it goes, at the ballot box, and surely no-one is naive enough to believe that if it doesn't go their way they will give up, any more than Labour or the Liberal Democrats will!