Asymptotic profile with the optimal convergence rate for a parabolic equation of chemotaxis in super-critical cases