Tensions and Anomalies on the Sky: Quest for New Physics at Cosmological Scales