Hope for thousands with ADHD as scientists say new brain treatment can 'transform' lives of sufferers