The number of self harm cases presenting in hospitals fell by 6% last year, primarily due to a drop in cases involving middle-aged women and men.