A major UK city is set to receive a direct train line to a beloved European country, with the route announced to be the first of its kind