Welded and seamless steel pipes suitable for plumbing installations