I don't really take a stance as someone who lives in England.
Would I like Scotland to stay? Yes. But only because it would feel weird for them to leave, regardless of anything else it would cause some upheaval. What do we do with our flag? Would the Country be renamed? How will our Olympic team function without the Scottish propping it up? Who will the Tories shit on once the Scottish are gone (Hint: Geordies, Brummies, Mancunians, and Scousers)
If they do go independent I hope it's a wake up call to the rest of the country as to how utterly poorly our government handles things, and I hope we can have a debate about how to restructure Parliament if/when the Scottish MPs leave.
Then again I also hope for tighter European integration in an effort to give use a European state that genuinely competes with US/Russia/China but that looks incredibly unlikely.
If they do go, well good on them, the SNP seems to have its head screwed on, hopefully they can maintain that.