So if the English moved into, say, Edinburgh en masse, then decided they wanted Edinburgh to join England and leave Scotland, that's too bad for Scotland?

What if all those ethnic neighborhoods in London decided they wanted to join their respective mother countries? There'd be China, India, Jamaica, etc., all having a piece of London. Democratic will of the people. And I'm sure the UK gov't would just happily go along with that.