Police seeking a Wigan Athletic fan whose disappearance sparked huge public searches and appeals have found a body.