Scottish Government faces major medium- and long-term budget challenges