This stunning destination has been revealed as the cheapest city for UK holidaymakers looking to book their next break.