DC-VSR: Spatially and Temporally Consistent Video Super-Resolution with Video Diffusion Prior