Ab initio studies of double Gamow-Teller transition and its correlation with neutrinoless double beta decay