An intense storm is bearing down on Sydney, with multiple suburbs told to “stay indoors”.