Wigan Athletic fan Darren Orme, whose disappearance sparked a massive search, died by drowning, a court heard.