The winners of the prestigious annual Tripadvisor Travellers' Choice Awards have been unveiled, with a Scottish city being crowned one of the best travel spots in the world.