The historic cathedral city has been crowned the world's most beautiful city, beating Venice and Barcelona.