A member of a royal family was found collapsed on the street of west London after indulging in a drugs binge while