Radio-spectral index distribution of SDSS-FIRST sources across optical diagnostic diagrams