SPIRIT: Short-term Prediction of solar IRradIance for zero-shot Transfer learning using Foundation Models