Method for generating overlap-guided compact ansatz for practical quantum chemistry, uses thereof and related computing systems