Near-Optimal Bounds for Generalized Orthogonal Procrustes Problem via Generalized Power Method