Oil and gas well completion equipment, namely, hydraulically and mechanically actuated sleeves for selective multi-zone stimulation operations