£500m to anchor new offshore supply chain as Humza Yousaf looks beyond oil and gas