The cheapest European summer holiday destination has just been revealed – and it boasts breathtaking medieval architecture and £2.30 pints – Secret Manchester