Foundation Models for Scientific Discovery: From Paradigm Enhancement to Paradigm Transition