Nearly 400,000 private prescriptions for ADHD medication were issued last year as patients sought to bypass lengthy NHS waiting lists, with people spending millions of pounds on treatment.