Coherent Load Profile Synthesis with Conditional Diffusion for LV Distribution Network Scenario Generation