Rain that battered Tayside and Fife was a ‘once in 600 years’ storm, says expert