Beans the cat went missing from his home near Glasgow before turning up weeks later south of the border in the West Midlands