Cosmological constraints on sub-horizon scales modified gravity theories with MGCLASS II