Multifaceted Applications of Microbial Pigments: Current Knowledge, Challenges and Future Directions for Public Health Implications