The "North's favourite Southerner" paid a visit to the popular Greater Manchester cafe