Scalable Quantum Computation of Highly Excited Eigenstates with Spectral Transforms