Scots don’t dislike Britain quite enough for a divorce, but the relationship is still testy