Scalar modes in extended hybrid metric-Palatini gravity: Weak field phenomenology