If in Scotland you can leave your heritable property to anyone you choose to. Moveable property is distributed according to the provisions within the Succession (Scotland) Act 1964. So you can make provision to leave millions of pounds worth of shares to Johnny, plus the ming vase, and Picasso paintings, but that part of the will would be ineffective. But the mansion cna be left to whoever you choose and you don't need to sell it for a small sum. In fact, if you did this, the sale (in Scotland) could be reduced if the court held that the sale was a gratuitous alienation.