A talented young rugby player from Wigan died after an accidental drugs overdose on a night out in Preston.