Table

from here

Every atom has a particular spectral characteristics when it is ionized or heated up. Some molecukes are strong enough to survive it as well, but as far as I know atoms dominate.

metals provide much stronger color than other materials

To look for color and material use 'spectral lines (material)' for search. Only atoms or very simple molecules make sense for this request. If spectral lines are numerous and spread out throughout spectrum, color will seem more white and less colorful.

Gasses provide significantly weaker color in atmospheric conditions usually. In gas lamps low pressure gas is used - neon, krypton, argon. But so are metal vapors - sodium, mercury. Gas lamps are used for convinience i think, and for particular color they provide.

In normal conditions adding gas like neon to the flame will not make the flame colorful, while metal will.

Table

from here

Sodium (yellow) and calcium (orange) seems to be the closest fit to your requested color

Every atom has a particular spectral characteristics when it is ionized or heated up. Some molecules are strong enough to survive it as well, but as far as I know atoms dominate.

Metals provide much stronger color than other materials

To look for color and material use 'spectral lines (material)' for search. Only atoms or very simple molecules make sense for this request. If spectral lines are numerous and spread out throughout the spectrum, color will seem more white and less colorful.

Gasses provide significantly weaker color in atmospheric conditions usually. In gas lamps low pressure gas is used - neon, krypton, argon. But so are metal vapors - sodium, mercury. Gas lamps are used for convinience i think, and for particular color they provide.

In normal conditions adding gas like neon to the flame will not make the flame colorful, while metal will.