Scotland's "best places to live" in 2025 have been crowned.