Real-World Robot Applications of Foundation Models: A Review