One of Edinburgh's most prestigious streets has been named as the most expensive place to buy a house in Scotland.