Forecasters say Sunday will be mostly “bright and dry” as thousands are expected to turn out to witness the Queen’s coffin cortege passing through Tayside and Fife.