Denoising diffusion probabilistic models are optimally adaptive to unknown low dimensionality