A Scottish city street has been named the "most expensive" in the country for property.