A spate of wild weather has brought on flash flooding across five states, with footage capturing the moment a ritzy restaurant in Sydney’s east was flooded.