Whilst I think that a No Deal Brexit will be disastrous for the UK and I would not wish it on anyone, the other side of the coin is that it would undoubtedly lead to a YES vote in a second Scottish Independence referendum. This would leave RUK without tariff free access to the food, including fish, prime beef, ect. produced in Scotland and the excess of oil, wind, wave and hydro power which currently flows effortlessly across the border. Meanwhile Scotland will prosper, still in the EU with tariff free access to the huge EU markets and an influx of Finance houses who will relocate their Headquarters from London to Edinburgh.
I expect there will be an influx of remainers from South of the Border, and exiled Scots, who will be welcomed warmly because one thing Scotland is short of is population.