The Scottish residential market has reached a turning point and is now attracting more buyers from London and further afield.