Large Language Models for Robotics: Opportunities, Challenges, and Perspectives