This Scottish city has been named sixth best in Europe by Lonely Planet