Foundation and Large-Scale AI Models in Neuroscience: A Comprehensive Review