With cheaper house prices and scenic surroundings, many are upping sticks and moving to another major UK city that's still got great transport connections to London