Large Language Models: A Comprehensive Survey of its Applications, Challenges, Limitations, and Future Prospects