An £800 million deal which will create two further battery energy storage sites in Scotland – each of which are the largest in Europe – has been hailed as “formidable” by First Minister John Swinney.