Understanding Stable Diffusion: A Comprehensive Guide to Applications in Science and Technology