I myself voted No in 2014, have never voted SNP, and I think it's perfectly legitimate to argue that we have another referendum. In Scotland we value EU membership very highly, and the direction that English/British politics has went in is entirely contrary to the principles that support the broadly centre-left consensus up North. Our Tories are probably more pro-EU than the Labour party currently is rn under Corbyn's leadership.
When Brown and Darling made their massive last-gasp pushes before the vote in 2014, the EU was at the absolute crux of the whole issue. We were told that we would risk our membership, whereas the UK was a safe bet - remember back then almost nobody thought that Brexit would actually happen, the vote was meant to be formality, so that Cameron could calm down the upper-class Brexit nutters in his party.
Unfortunately for all the normal working people of this country, especially in Scotland and NI, where the Murdoch media isn't trusted so much and the vacuous rhetoric of UKIP isn't taken credibly, the power games of Etonian school boys have hit their wallets pretty hard.