Things are a little murky regarding partisanship. Both Labour and Tory members are fleeing because of dissatisfaction with their leaders' Brexit positions. In the recent local elections, both parties lost support--but especially the Tories. While the leaders claim that it showed that people just wanted to "get on with Brexit" the fact is that it was the Lib Dems and Greens that picked up the most seats, both of which oppose Brexit. Even the extreme right UKIP lost seats. Yet current polling for the European Parliament shows Farage with a strong support. We'll see what the actual results look like. It might just be an artifact of his one-dimensional appeal.
As for Scotland leaving the UK, well, stay tuned. The Cameron government was reasonably confident that Scotland would reject independence, so they allowed the referendum to occur in 2014. You're certainly right that Scotland is opposed to Brexit, and that could make them want to leave the UK once it leaves the EU. But next time, they might not get permission, so it could turn into something like the Catalan situation in Spain. Even if it did manage to secure independence, it would take several years to become an EU member. And once in the EU, the whole Northern Ireland border issue would be replicated at the Scottish border with England. It might be more trouble than it's worth for Scotland.