From what I've read, Scotland is pretty much insolvent and still has generous social programs because England keeps them afloat.
It's a very narrow view of wealth flows, looking at the bigger picture then more flows back the other way.
e.g. See the example of Strathclyde Police Training and Recruitment Centre here:
https://www.taxresearch.org.uk/Blog/2019/08/16/the-burden-of...