Ultra-narrow electromagnetically induced transparency in the visible and near-infrared regions