Hypnotherapy and talking therapy are the best treatments for long-term stomach pain in children, a new study suggests.