A Survey on Spatio-Temporal Prediction: From Transformers to Foundation Models | Synapse