The cheapest and most expensive areas to buy property in Scotland have been revealed.