The Scottish government has announced a new proposal to end all its overseas trade backing and promotion activities solely focused on fossil fuel goods and services by COP26.