John, who had stage four colorectal cancer, 'was relieved and relaxed into sleep' eight minutes after taking the substance and was dead after 18