A historic UK city has been named among the world's top trending holiday destinations for 2027, beating expectations with its coastal scenery and rich history.