The "core" of countries rarely likes their own peripheries. Scotland throwing its weight around will cause antipathy because many English people don't really believe in
Scotland (or Wales).
Nicola Sturgeon, the first minister of Scotland, has suggested that her Parliament could withhold consent, sparking a constitutional crisis.
That, in turn, could be an opportunity for leaders wishing to avoid a Brexit. The next prime minister could tell voters that he or she would like to carry out their will, but that leaving Europe is impossible without Scottish approval.