Foundation Models in AI: A Comprehensive Guide to Applications and Future Trends