Tragic father who died in Magaluf had 'taken cocaine before he died'