Of COURSE the Scots want another swing at independence, they weren't happy at the first result and only grudgingly accepted it in the first place.
The fact is that Scotland is a proto-Socialist state with exceedingly generous programs and benefits NOT supported by their own industry or tax base. Their fanciful extrapolations of a post-Scotcession world are sheer fiction, pre-supposing every possible advantage (Scotland gets to keep every drop the North Seas oil at no cost to themselves; Scotland gets to keep using the GBP; more or less free access to the EU) and hand-waving the rest. In fact, the economic picture now is even MORE bleak than it was then with oil at half the price it was. Their golden goose is laying eggs distinctly non-golden today.
OF COURSE they want to stay in the EU. They need to make sure whatever udder they're latched onto is on the healthiest possible cow.
But be clear:NOBODY will accept them into the EU. There are so many nascent disaffected minorities from the Basques to the Bretons to the Flemish that NO major state will want to validate the quixotic secessionist movement by granting it the recognition of admission to the EU.