The use of prescription medications for Attention-Deficit Hyperactivity Disorder (ADHD) has tripled in the last decade - with women seeing the most "dramatic" increase, according to a major new study.