Roof collapses above diners in Scots restaurant after rain batters country