No, we'd probably see a second vote only if the SNP took a majority in the Scottish parliament again and the UK voted to exit the EU. Leaving the EU is really bad for Scotland (arguably all parts of the UK, but Scotland especially for many economic reasons), and might spur a bunch of people that voted "no" last time to vote "yes" if it were held again.

Like I said, I consider that unlikely, but it's a risk.